|
The Oracle Database OLAP Option implements On-line Analytical Processing (OLAP) within an Oracle database environment. Oracle Corporation markets the Oracle Database OLAP Option as an extra-cost option to supplement the "Enterprise Edition" of its database. (Oracle offers Essbase for customers without the Oracle Database or who require multiple data-sources to load their cubes.) As of Oracle Database 11g, the Oracle database optimizer can transparently redirect SQL queries to levels within the OLAP Option cubes. The cubes are managed and can take the place of multi-dimensional materialized views, simplifying Oracle data-warehouse management and speeding up query response. == Logical components == The Oracle Database OLAP Option offers: * an OLAP analytic engine * workspaces * an analytic workspace manager (AWM)〔 ("Introduction to the OLAP Java API" ) in ''Oracle OLAP Java API Developer's Guide, 11g Release 1 (11.1)'', 2007. Chapter 1.〕 * a worksheet environment * OLAP DML for DDL and DML * an interface from SQL * an analytic workspace Java API * a Java-based OLAP API 抄文引用元・出典: フリー百科事典『 ウィキペディア（Wikipedia）』 ■ウィキペディアで「The Oracle Database OLAP Option implements On-line Analytical Processing (OLAP) within an Oracle database environment. Oracle Corporation markets the Oracle Database OLAP Option as an extra-cost option to supplement the "Enterprise Edition" of its database. (Oracle offers Essbase for customers without the Oracle Database or who require multiple data-sources to load their cubes.) As of Oracle Database 11g, the Oracle database optimizer can transparently redirect SQL queries to levels within the OLAP Option cubes. The cubes are managed and can take the place of multi-dimensional materialized views, simplifying Oracle data-warehouse management and speeding up query response.== Logical components ==The Oracle Database OLAP Option offers:* an OLAP analytic engine* workspaces* an analytic workspace manager (AWM) ("Introduction to the OLAP Java API" ) in ''Oracle OLAP Java API Developer's Guide, 11g Release 1 (11.1)'', 2007. Chapter 1.* a worksheet environment* OLAP DML for DDL and DML* an interface from SQL * an analytic workspace Java API* a Java-based OLAP API」の詳細全文を読む スポンサード リンク
|